Setting advanced connection properties

In the Advanced tab, you can set the following properties:

You can set the following properties:

• Max file size (KB): Select or type the maximum size (in KB) of a CSV file before the file is loaded into the Google Cloud BigQuery target database.
• Use compression: When selected, the endpoint will compress (using gzip) the CSV files before uploading them to Google Cloud BigQuery.

• Dataset creation

  • Create datasets automatically - Replicate will create the datasets automatically.

    Information noteCreate datasets automatically requires a higher permission level than Do not create datasets. For more information, see Prerequisites .

  • Do not create datasets - Assumes the required datasets already exist on the target. When using this option, you must do one of the following:

    • Enter the name of the existing dataset in the task settings' Target table schema field.

      -OR-

    • Enter the name of the existing dataset in the following two places:

      • The table settings' Table Schema field.

      • The Create target control tables in schema field in the task settings' Control Tables tab.

• Location: Where to upload the dataset created by Replicate. If you choose Other, set the location code in the Region code field. Region codes are listed as "Region keys" in https://cloud.google.com/bigquery/docs/locations.

• Default dataset prefix: Specify a prefix for the BigQuery dataset where you want Replicate to create and update the target tables.

  Information note

  This is required when the Apply Changes replication option is selected.

• Create tables as clustered by primary key: When this option is selected, the target tables will be created as clustered (according to the first four Primary Key columns that support clustering). In general, clustered tables usually provide much better query performance as well as reducing billing costs.

  Information note

  • Only tables with primary keys of the following data types can be created as clustered: DATE, BOOL, GEOGRAPHY, INT64, NUMERIC, STRING, and TIMESTAMP.
  • If you select this option and then later decide that you do not want the tables to be created as clustered on the target, turn off this option and reload the task.

• Use proxy server - Select this option to connect via a proxy server, and then provide the proxy connection settings:

  • Host name: The host name of the proxy server.
  • Port: The port via which to access the proxy server.
  • User name: The user name for the proxy server.
  • Password: The password for the proxy server.

Internal parameters

Internal parameters are parameters that are not exposed in the UI. You should only use them if instructed by Qlik Support.

To add internal Qlik Replicate parameters:

1. Click the Internal Parameters link.

   The Internal Parameters dialog box opens.

2. In the edit box, type the name of the parameter you need to add and then click it.
3. The parameter is added to the table below the search box with its default value.
4. Change the default value as required.
5. To reset the parameter value to its default, click the "Restore default value" icon at the end of the row.

More options

These options are not exposed in the UI as they are only relevant to specific versions or environments. Consequently, do not set these options unless explicitly instructed to do so by Qlik Support or product documentation.

To set an option, simply copy the option into the Add feature name field and click Add. Then set the value or enable the option according to the instructions you received.

Settings summary

You can view a summary of your settings by clicking the Setting Summary link. This is useful if you need to send a summary of your settings to Qlik Support.